Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	2778
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	282.1 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`gross_revenue` is highly overall correlated with `total_orders` and 3 other fields	High correlation
`total_orders` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`total_products_ordered` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`total_quantity` is highly overall correlated with `gross_revenue` and 3 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`avg_basket_size_quantity` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_ticket` is highly overall correlated with `avg_basket_size_products`	High correlation
`avg_basket_size_products` is highly overall correlated with `total_products_ordered` and 1 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`frequency` is highly skewed (γ1 = 42.54355149)	Skewed
`avg_ticket` is highly skewed (γ1 = 27.7027396)	Skewed
`qty_returns` is highly skewed (γ1 = 21.64504304)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`qty_returns` has 1481 (53.3%) zeros	Zeros

Reproduction

Analysis started	2023-08-11 00:15:37.316985
Analysis finished	2023-08-11 00:15:46.746406
Duration	9.43 seconds
Software version	ydata-profiling vv4.3.1
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	2778
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15284.845

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	12347
5-th percentile	12625.85
Q1	13814.25
median	15242.5
Q3	16779.75
95-th percentile	17950.15
Maximum	18287
Range	5940
Interquartile range (IQR)	2965.5

Descriptive statistics

Standard deviation	1715.6364
Coefficient of variation (CV)	0.11224428
Kurtosis	-1.206922
Mean	15284.845
Median Absolute Deviation (MAD)	1484
Skewness	0.016456349
Sum	42461299
Variance	2943408.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17930	1	< 0.1%
15813	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
Other values (2768)	2768	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION

Distinct	2763
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2840.6605

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	36.56
5-th percentile	262.567
Q1	626.585
median	1165.93
Q3	2419.6075
95-th percentile	7461.5245
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1793.0225

Descriptive statistics

Standard deviation	10457.915
Coefficient of variation (CV)	3.6815081
Kurtosis	373.4173
Mean	2840.6605
Median Absolute Deviation (MAD)	687.275
Skewness	17.111453
Sum	7891354.8
Variance	1.0936798 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
734.94	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
379.65	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
2053.02	2	0.1%
1314.45	2	0.1%
331	2	0.1%
Other values (2753)	2758	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ)

ZEROS

Distinct	253
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.924406

Minimum	0
Maximum	373
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	373
Range	373
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.851053
Coefficient of variation (CV)	1.2095173
Kurtosis	3.4605459
Mean	56.924406
Median Absolute Deviation (MAD)	24
Skewness	1.9029993
Sum	158136
Variance	4740.4675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (243)	2031	73.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.5%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
373	1	< 0.1%
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%

total_orders
Real number (ℝ)

HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0475162

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.0662295
Coefficient of variation (CV)	1.4991658
Kurtosis	184.14404
Mean	6.0475162
Median Absolute Deviation (MAD)	2
Skewness	10.629927
Sum	16800
Variance	82.196517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	784	28.2%
3	499	18.0%
4	393	14.1%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	784	28.2%
3	499	18.0%
4	393	14.1%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

total_products_ordered
Real number (ℝ)

HIGH CORRELATION

Distinct	467
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.59071

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	399.45
Maximum	7838
Range	7836
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.61455
Coefficient of variation (CV)	2.1422411
Kurtosis	337.20251
Mean	129.59071
Median Absolute Deviation (MAD)	45
Skewness	15.356421
Sum	360003
Variance	77069.838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	38	1.4%
35	35	1.3%
27	30	1.1%
29	30	1.1%
26	30	1.1%
25	28	1.0%
31	27	1.0%
19	27	1.0%
15	27	1.0%
33	26	0.9%
Other values (457)	2480	89.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	11	0.4%
3	12	0.4%
4	16	0.6%
5	16	0.6%
6	25	0.9%
7	14	0.5%
8	14	0.5%
9	19	0.7%
10	19	0.7%
11	23	0.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

total_quantity
Real number (ℝ)

HIGH CORRELATION

Distinct	1638
Distinct (%)	59.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1669.085

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330
median	700
Q3	1478
95-th percentile	4605.25
Maximum	196844
Range	196842
Interquartile range (IQR)	1148

Descriptive statistics

Standard deviation	5885.7377
Coefficient of variation (CV)	3.526326
Kurtosis	486.26094
Mean	1669.085
Median Absolute Deviation (MAD)	451
Skewness	18.191493
Sum	4636718
Variance	34641909
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
493	7	0.3%
219	7	0.3%
1200	7	0.3%
200	7	0.3%
516	7	0.3%
272	7	0.3%
260	7	0.3%
Other values (1628)	2702	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%
50255	1	< 0.1%

frequency
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1225
Distinct (%)	44.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.053223357

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0087463557
Q1	0.015810277
median	0.024390244
Q3	0.041882808
95-th percentile	0.11764706
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.026072532

Descriptive statistics

Standard deviation	0.34733528
Coefficient of variation (CV)	6.5259935
Kurtosis	2046.3274
Mean	0.053223357
Median Absolute Deviation (MAD)	0.010697475
Skewness	42.543551
Sum	147.85449
Variance	0.1206418
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.02127659574	13	0.5%
0.07692307692	13	0.5%
0.02564102564	13	0.5%
Other values (1215)	2630	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

avg_basket_size_quantity
Real number (ℝ)

HIGH CORRELATION

Distinct	1937
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	231.18451

Minimum	1
Maximum	6009.3333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.2625
median	171.92857
Q3	278.07143
95-th percentile	584.95
Maximum	6009.3333
Range	6008.3333
Interquartile range (IQR)	174.80893

Descriptive statistics

Standard deviation	261.58041
Coefficient of variation (CV)	1.131479
Kurtosis	115.58811
Mean	231.18451
Median Absolute Deviation (MAD)	81.166667
Skewness	7.7180437
Sum	642230.57
Variance	68424.312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
75	8	0.3%
60	8	0.3%
208	7	0.3%
197	7	0.3%
73	7	0.3%
82	7	0.3%
136	7	0.3%
105	7	0.3%
Other values (1927)	2700	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%
1866.933333	1	< 0.1%

avg_ticket
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	2776
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.086257

Minimum	2.1505882
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.8536955
Q1	12.44788
median	17.953447
Q3	25.019036
95-th percentile	87.543921
Maximum	4453.43
Range	4451.2794
Interquartile range (IQR)	12.571157

Descriptive statistics

Standard deviation	107.53578
Coefficient of variation (CV)	3.3514591
Kurtosis	1056.5006
Mean	32.086257
Median Absolute Deviation (MAD)	6.3234675
Skewness	27.70274
Sum	89135.622
Variance	11563.944
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
25.6761194	1	< 0.1%
44.95564103	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
Other values (2766)	2766	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%
602.4531323	1	< 0.1%

avg_basket_size_products
Real number (ℝ)

HIGH CORRELATION

Distinct	897
Distinct (%)	32.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.12752

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.5113636
median	13.5
Q3	22
95-th percentile	45.0375
Maximum	177
Range	176.8
Interquartile range (IQR)	14.488636

Descriptive statistics

Standard deviation	14.255607
Coefficient of variation (CV)	0.83232172
Kurtosis	10.02027
Mean	17.12752
Median Absolute Deviation (MAD)	6.6666667
Skewness	2.2478459
Sum	47580.252
Variance	203.22234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	34	1.2%
13	33	1.2%
9	32	1.2%
16	32	1.2%
7	32	1.2%
12	31	1.1%
14	29	1.0%
6	29	1.0%
17	29	1.0%
18.5	29	1.0%
Other values (887)	2468	88.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93.33333333	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

avg_recency_days
Real number (ℝ)

HIGH CORRELATION

Distinct	1255
Distinct (%)	45.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-69.743243

Minimum	-366
Maximum	-1
Zeros	0
Zeros (%)	0.0%
Negative	2778
Negative (%)	100.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	-366
5-th percentile	-202
Q1	-87.666667
median	-50.25
Q3	-28.368881
95-th percentile	-11.599062
Maximum	-1
Range	365
Interquartile range (IQR)	59.297786

Descriptive statistics

Standard deviation	62.905638
Coefficient of variation (CV)	-0.90196032
Kurtosis	4.8460142
Mean	-69.743243
Median Absolute Deviation (MAD)	25.916667
Skewness	-2.0584051
Sum	-193746.73
Variance	3957.1193
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-70	21	0.8%
-14	18	0.6%
-35	18	0.6%
-49	16	0.6%
-46	16	0.6%
-42	16	0.6%
-55	15	0.5%
-26	15	0.5%
-29	15	0.5%
-31	15	0.5%
Other values (1245)	2613	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-366	1	< 0.1%
-365	1	< 0.1%
-363	1	< 0.1%
-357	2	0.1%
-356	1	< 0.1%
-355	2	0.1%
-352	1	< 0.1%
-351	1	< 0.1%
-350	3	0.1%
-349	2	0.1%

Value	Count	Frequency (%)
-1	8	0.3%
-2	3	0.1%
-2.5	1	< 0.1%
-2.601398601	1	< 0.1%
-3	6	0.2%
-3.321428571	1	< 0.1%
-3.330357143	1	< 0.1%
-3.5	2	0.1%
-4	5	0.2%
-4.144444444	1	< 0.1%

qty_returns
Real number (ℝ)

SKEWED ZEROS

Distinct	204
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.939885

Minimum	0
Maximum	9014
Zeros	1481
Zeros (%)	53.3%
Negative	0
Negative (%)	0.0%
Memory size	43.4 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	96.3
Maximum	9014
Range	9014
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	290.45597
Coefficient of variation (CV)	8.3130201
Kurtosis	572.76241
Mean	34.939885
Median Absolute Deviation (MAD)	0
Skewness	21.645043
Sum	97063
Variance	84364.668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.3%
1	131	4.7%
2	118	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	56	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (194)	653	23.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1481	53.3%
1	131	4.7%
2	118	4.2%
3	82	3.0%
4	72	2.6%
5	56	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%
1594	1	< 0.1%

Auto

Heatmap
Table

	customer_id	gross_revenue	recency_days	total_orders	total_products_ordered	total_quantity	frequency	avg_basket_size_quantity	avg_ticket	avg_basket_size_products	avg_recency_days	qty_returns
customer_id	1.000	-0.086	0.013	0.014	0.012	-0.079	0.013	-0.121	-0.141	-0.002	-0.012	-0.057
gross_revenue	-0.086	1.000	-0.375	0.764	0.724	0.921	0.254	0.601	0.271	0.105	0.383	0.458
recency_days	0.013	-0.375	1.000	-0.450	-0.394	-0.367	-0.123	-0.105	0.036	0.003	-0.215	-0.185
total_orders	0.014	0.764	-0.450	1.000	0.660	0.704	0.317	0.127	0.089	-0.178	0.450	0.425
total_products_ordered	0.012	0.724	-0.394	0.660	1.000	0.710	0.196	0.404	-0.381	0.547	0.287	0.327
total_quantity	-0.079	0.921	-0.367	0.704	0.710	1.000	0.235	0.760	0.193	0.149	0.354	0.423
frequency	0.013	0.254	-0.123	0.317	0.196	0.235	1.000	0.022	0.083	-0.167	0.909	0.178
avg_basket_size_quantity	-0.121	0.601	-0.105	0.127	0.404	0.760	0.022	1.000	0.196	0.385	0.081	0.211
avg_ticket	-0.141	0.271	0.036	0.089	-0.381	0.193	0.083	0.196	1.000	-0.639	0.128	0.188
avg_basket_size_products	-0.002	0.105	0.003	-0.178	0.547	0.149	-0.167	0.385	-0.639	1.000	-0.175	-0.066
avg_recency_days	-0.012	0.383	-0.215	0.450	0.287	0.354	0.909	0.081	0.128	-0.175	1.000	0.384
qty_returns	-0.057	0.458	-0.185	0.425	0.327	0.423	0.178	0.211	0.188	-0.066	0.384	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	gross_revenue	recency_days	total_orders	total_products_ordered	total_quantity	frequency	avg_basket_size_quantity	avg_ticket	avg_basket_size_products	avg_recency_days	qty_returns
0	17850	5391.21	372.0	34.0	297.0	1733.0	17.000000	50.970588	18.152222	0.617647	-35.500000	40.0
1	13047	3232.59	56.0	9.0	171.0	1390.0	0.028302	154.444444	18.904035	11.666667	-27.250000	35.0
2	12583	6705.38	2.0	15.0	232.0	5028.0	0.040323	335.200000	28.902500	7.600000	-23.187500	50.0
3	13748	948.25	95.0	5.0	28.0	439.0	0.017921	87.800000	33.866071	4.800000	-92.666667	0.0
4	15100	876.00	333.0	3.0	3.0	80.0	0.073171	26.666667	292.000000	0.333333	-8.600000	22.0
5	15291	4623.30	25.0	14.0	102.0	2102.0	0.040115	150.142857	45.326471	4.357143	-23.200000	29.0
6	14688	5630.87	7.0	21.0	327.0	3621.0	0.057221	172.428571	17.219786	7.047619	-18.300000	399.0
7	17809	5411.91	16.0	12.0	61.0	2057.0	0.033520	171.416667	88.719836	3.833333	-35.700000	41.0
8	15311	60767.90	0.0	91.0	2379.0	38194.0	0.243316	419.714286	25.543464	6.230769	-4.144444	474.0
9	16098	2005.63	87.0	7.0	67.0	613.0	0.024390	87.571429	29.934776	4.857143	-47.666667	0.0

	customer_id	gross_revenue	recency_days	total_orders	total_products_ordered	total_quantity	frequency	avg_basket_size_quantity	avg_ticket	avg_basket_size_products	avg_recency_days	qty_returns
4255	17290	525.24	3.0	2.0	102.0	404.0	0.142857	202.000000	5.149412	46.000000	-13.0	0.0
4261	14785	77.40	10.0	2.0	3.0	84.0	0.333333	42.000000	25.800000	1.000000	-5.0	0.0
4262	17254	272.44	4.0	2.0	112.0	252.0	0.166667	126.000000	2.432500	50.000000	-11.0	0.0
4276	17232	421.52	2.0	2.0	36.0	203.0	0.153846	101.500000	11.708889	15.000000	-12.0	0.0
4277	17468	137.00	10.0	2.0	5.0	116.0	0.400000	58.000000	27.400000	2.500000	-4.0	0.0
4280	13596	697.04	5.0	2.0	166.0	406.0	0.250000	203.000000	4.199036	66.500000	-7.0	0.0
4285	14893	1237.85	9.0	2.0	73.0	799.0	0.666667	399.500000	16.956849	36.000000	-2.0	0.0
4304	14126	706.13	7.0	3.0	15.0	508.0	0.750000	169.333333	47.075333	4.666667	-3.0	50.0
4308	13521	1092.39	1.0	3.0	435.0	733.0	0.300000	244.333333	2.511241	104.000000	-4.5	0.0
4313	15060	301.84	8.0	4.0	120.0	262.0	2.000000	65.500000	2.515333	20.000000	-1.0	0.0

Overview

Variables

Interactions

Correlations

Missing values

Sample